﻿CREATE TABLE [dbo].[Sb_Info] (
    [sblsh]  SMALLINT     IDENTITY (1, 1) NOT NULL,
    [sbbs]   VARCHAR (50) NULL,
    [sbh]    SMALLINT     NULL,
    [sbyt]   SMALLINT     NULL,
    [sblx]   SMALLINT     NULL,
    [kzlx]   SMALLINT     NULL,
    [ljlx]   SMALLINT     NULL,
    [comip]  VARCHAR (30) NULL,
    [bddk]   VARCHAR (10) NULL,
    [sjtbzt] SMALLINT     DEFAULT ((3)) NULL,
    CONSTRAINT [PK_SB_INFO] PRIMARY KEY CLUSTERED ([sblsh] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0:未同步  1:同步失败 2:同步成功 3:新增或同步失败后变更或未同步后变更', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sb_Info', @level2type = N'COLUMN', @level2name = N'sjtbzt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'连接类型 0:RS232/RS485 1:TCP/IP 2:USB', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sb_Info', @level2type = N'COLUMN', @level2name = N'ljlx';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0:单门单向 1:单门双向 2:双门单向 3:双门双向 4:四门单向', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sb_Info', @level2type = N'COLUMN', @level2name = N'kzlx';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0：中控 1：广安达 2:LED 3:DVR 4:兴致读卡器 5:复旦微电子读卡器 6:C3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sb_Info', @level2type = N'COLUMN', @level2name = N'sblx';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0：门禁 1：通用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sb_Info', @level2type = N'COLUMN', @level2name = N'sbyt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'记录所有设备共同信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sb_Info';

